﻿CREATE TABLE [dbo].[SupplierAddress] (
    [Id_SupplierAddress] INT           IDENTITY (1, 1) NOT NULL,
    [Id_Supplier]        INT           NOT NULL,
    [Id_Address_Type]    INT           NOT NULL,
    [Street]             VARCHAR (100) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Number]             VARCHAR (10)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Complement]         VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [District]           VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [ZipCode]            VARCHAR (15)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Id_City]            INT           NULL
);

